This section describes the skills and knowledge and their level required for this unit

Required skills

apply best practice in backup and recovery strategies

apply keyboarding skills to maintain data

apply safe and effective ergonomic workplace practices

collate and present data

conduct checks for accurate and consistent information

create simple queries using simple formulae

interpret and evaluate the purposes and uses of various features of databases

prepare reports for analysis and evaluation of information in a defined range of areas

read and interpret complex instructions and technical material

use processes flexibly and interchangeably to solve routine problems

Required knowledge

backup and recovery methodologies

common database performance problems and solutions

data analysis techniques

data entry procedures and processes

database administration security and storage requirements

database diagnostic tools and their functions

energy and resource conservation

OHS guidelines including ergonomic requirements

range of database software and hardware and their application

report and other documentation formats

The evidence guide provides advice on assessment and must be read in conjunction with the performance criteria required skills and knowledge range statement and the Assessment Guidelines for the Training Package

Critical aspects for assessment and evidence required to demonstrate competency in this unit

A person who demonstrates competency in this unit must be able to provide evidence of

accurately diagnosing and rectifying errors and lags in data processing

implementing a broad application of database functions using accurate data inputting techniques to complete work tasks within designated timeframes

monitoring and reviewing database effectiveness and using constructive feedback to improve and maintain database systems

producing reports in required formats in a timely manner and reviewing for accuracy compatibility and reliability of data

using established storage protection and backup procedures and security and access systems to maintain database effectiveness and data integrity

Context of and specific resources for assessment

Context of assessment includes

a setting in the workplace or environment that simulates the conditions of performance described in the elements performance criteria and range statement

Resource implications for assessment include

access to plain English version of relevant statutes and procedures

access to a registered provider of assessment services

access to a suitable venue and equipment

assessment instruments including personal planner and assessment record book

work schedules organisational policies and duty statements

Reasonable adjustments must be made to assessment processes where required for people with disabilities This could include access to modified equipment and other physical resources and the provision of appropriate assessment support

Method of assessment

This unit of competency could be assessed using the following methods of assessment

observation of processes and procedures

questioning of underpinning knowledge and skills

Guidance information for assessment

Assessment processes and techniques must be culturally appropriate and suitable to the language literacy and numeracy capacity of the candidate and the competency being assessed In all cases where practical assessment is used it should be combined with targeted questioning to assess the underpinning knowledge

Oral questioning or written assessment may be used to assess underpinning knowledge In assessment situations where the candidate is offered a choice between oral questioning and written assessment questions are to be identical

Supplementary evidence may be obtained from relevant authenticated correspondence from existing supervisors team leaders or specialist training staff

Legislative requirements may relate to:

Organisational requirements may relate to:

Ergonomic considerations may include:

Conservationtechniques may include:

Security and accessprocedures may include:

Back-up:

Data entry, output and presentationprocedures include:

Sourcesmay include:

Checksmay include:

Diagnosismay relate to:

Relevant personsmay include:

Feedbackmay include:

Procedures for thestorage and protection of datamay relate to:

Documentationmay include: